Re: pid gets overwritten in OSX - Mailing list pgsql-general

From Francois Suter
Subject Re: pid gets overwritten in OSX
Date
Msg-id v04210100b8eea88562f7@[192.168.1.34]
Whole thread Raw
In response to Re: pid gets overwritten in OSX  (Gregory Seidman <gss+pg@cs.brown.edu>)
Responses Re: pid gets overwritten in OSX  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
>You'll have to provide more information. I am running OSX 10.1.4 and both
>PostgreSQL 7.1.2 and MySQL and I have never seen any such behavior. The
>only way I could even imagine them interacting is if you are trying to use
>the same directory for both, and even then it shouldn't happen since MySQL
>and PostgreSQL use different naming schemes for their pid files.

No, I'm definitely not using the same directory for both. As for more
info, I'm using Postgres 7.2.

>Is it possible that PostgreSQL isn't coming up after a reboot and the pid
>file just happens to have an old pid from the last boot?

It could be. I have been thinking along this line. I could imagine
the following scenario: Postgres starts after quite a few other
processes, tries to start with the pid stored in the postmaster.pid
file and actually doesn't start because the pid is already in use. Is
there an error log somewhere where such an error might appear?

Thanks.


--------
François

Home page: http://www.monpetitcoin.com/
"A fox is a wolf who sends flowers"

pgsql-general by date:

Previous
From: Uros Gruber
Date:
Subject: Re: Auth problem in pg_hdba.conf
Next
From: Mark kirkwood
Date:
Subject: Re: Performance Issues with count()